bug in sqlDescribeCol for the result set returned by a stored

am 17.09.2009 14:07:52 von the6campbells

--001636832a6c68a2250473c4ddb6
Content-Type: text/plain; charset=ISO-8859-1

Does not seem to matter if the driver has server side prepare, parse etc
options enabled.

Would someone also confirm if raising bugs via the web page on the postgres
web site is also for ODBC, JDBC etc issues or not.

> Bug reference: 5056
> Logged by: the6campbells
> Email address: the6campbells@gmail.com
> PostgreSQL version: 8.4.1
> Operating system: windows
> Description: SQLDescribeColW for function returning a result set
> incorrectly setting sql_nullable
> Details:
>
> create table TSET1 (RNUM integer not null, C1 integer, C2 char(3));
>
> create function PRES ( )
> returns setof TSET1 as
> '
> select RNUM, C1, C2 from TSET1;
> ' LANGUAGE 'sql'
> ;
>
> in ODBC test sqlPrepare { call pres } then describe the columns. first
> column should be SQL_NO_NULLS not NULLABLE.
>
> Describe Column All:
> icol, szColName,
*pcbColName, *pfSqlType, *pcbColDef, *pibScale,
> *pfNullable
>
1, rnum, 4, SQL_INTEGER=4, 10, 0, SQL_NULLABLE=1
>
2, c1, 2, SQL_INTEGER=4, 10, 0, SQL_NULLABLE=1
>
3, c2, 2, SQL_WCHAR=-8, 3, 0, SQL_NULLABLE=1

--001636832a6c68a2250473c4ddb6
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

>Does not seem to matter if the driver has server side prepare, parse etc o=
ptions enabled.=A0

Would someone also confirm if r=
aising bugs via the web page on the postgres web site is also for ODBC, JDB=
C etc issues or not.

> Bug reference: =A0 =A0 =A05056
> L=
ogged by: =A0 =A0 =A0 =A0 =A0the6campbells
> Email address: =A0 =A0 =
=A0 36); ">the6campbells@gmail.com

> PostgreSQL version: 8.4.1
> Operating system: =A0 windows
>=
; Description: =A0 =A0 =A0 =A0SQLDescribeColW for function returning a resu=
lt set
> incorrectly setting sql_nullable
> Details:
> >> create table TSET1 (RNUM integer not null, C1 integer, C2 char(3)); r>
>
> create function PRES ( )
> returns setof TSET1 as
>=
; '
> =A0select RNUM, C1, C2 from TSET1;
> ' =A0LANGUAG=
E 'sql'
> ;
>
> in ODBC test sqlPrepare { call pr=
es } then describe the columns. first

> column should be SQL_NO_NULLS not NULLABLE.
>
> Describe C=
olumn All:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0icol, szColName, *pc=
bColName, *pfSqlType, *pcbColDef, *pibScale,
> *pfNullable

> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 =A0 =A0 =A01, rnum, 4, SQL_INTEGER=3D4, 10, 0, SQL_NULLABLE=3D1
>=
; =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 =A0 =A0 =A0 =A0 =A0 =A02, c1, 2, SQL_INTEGER=3D4, 10, 0, SQL_NULLABLE=
=3D1

> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A03, c2, 2, SQL_WCHAR=3D-8, 3, 0, SQL_NULLABL=
E=3D1

collapse;">

--001636832a6c68a2250473c4ddb6--

Re: bug in sqlDescribeCol for the result set returned by astored procedure

am 18.09.2009 17:58:44 von Hiroshi Inoue

the6campbells wrote:
> Does not seem to matter if the driver has server side prepare, parse etc
> options enabled.

Unfortunately it seems very difficult to detect that the field
is not null.

regards,
Hiroshi Inoue

> Would someone also confirm if raising bugs via the web page on the
> postgres web site is also for ODBC, JDBC etc issues or not.
>
>
>> Bug reference: 5056
>> Logged by: the6campbells
>> Email address: the6campbells@gmail.com
>
>> PostgreSQL version: 8.4.1
>> Operating system: windows
>> Description: SQLDescribeColW for function returning a result set
>> incorrectly setting sql_nullable
>> Details:
>>
>> create table TSET1 (RNUM integer not null, C1 integer, C2 char(3));
>>
>> create function PRES ( )
>> returns setof TSET1 as
>> '
>> select RNUM, C1, C2 from TSET1;
>> ' LANGUAGE 'sql'
>> ;
>>
>> in ODBC test sqlPrepare { call pres } then describe the columns. first
>> column should be SQL_NO_NULLS not NULLABLE.
>>
>> Describe Column All:
>> icol,
> szColName, *pcbColName, *pfSqlType, *pcbColDef, *pibScale,
>> *pfNullable
>>
> 1, rnum, 4, SQL_INTEGER=4, 10, 0, SQL_NULLABLE=1
>>
> 2, c1, 2, SQL_INTEGER=4, 10, 0, SQL_NULLABLE=1
>>
> 3, c2, 2, SQL_WCHAR=-8, 3, 0, SQL_NULLABLE=1

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc